Text copied to clipboard!

Title

Text copied to clipboard!

PLSQL Developer

Description

Text copied to clipboard!
We are looking for a skilled PLSQL Developer to join our technology team. As a PLSQL Developer, you will be responsible for designing, developing, and maintaining PL/SQL code for database applications. You will work closely with application developers, database administrators, and business analysts to ensure that our database solutions are robust, efficient, and scalable. Your primary duties will include writing complex PL/SQL queries, stored procedures, triggers, and functions, as well as optimizing existing code for performance and reliability. You will also be expected to troubleshoot and resolve database-related issues, participate in code reviews, and contribute to the overall database architecture and design. The ideal candidate will have a strong background in Oracle databases, excellent problem-solving skills, and the ability to work both independently and as part of a team. Experience with data modeling, ETL processes, and performance tuning is highly desirable. You should also be comfortable working in a fast-paced environment and managing multiple tasks simultaneously. Strong communication skills are essential, as you will be required to interact with both technical and non-technical stakeholders. If you are passionate about database development and eager to contribute to innovative projects, we encourage you to apply for this exciting opportunity.

Responsibilities

Text copied to clipboard!
  • Design, develop, and maintain PL/SQL code for database applications
  • Write and optimize complex queries, stored procedures, triggers, and functions
  • Collaborate with developers, DBAs, and business analysts on database solutions
  • Troubleshoot and resolve database-related issues and bugs
  • Participate in code reviews and ensure adherence to best practices
  • Contribute to database architecture and data modeling efforts
  • Perform performance tuning and optimization of PL/SQL code
  • Document database processes, procedures, and code changes
  • Support ETL processes and data integration tasks
  • Ensure database security and compliance with company policies

Requirements

Text copied to clipboard!
  • Bachelor’s degree in Computer Science, Information Technology, or related field
  • Proven experience as a PL/SQL Developer or similar role
  • Strong knowledge of Oracle databases and PL/SQL programming
  • Experience with performance tuning and query optimization
  • Familiarity with data modeling and database design
  • Ability to troubleshoot and resolve complex database issues
  • Excellent analytical and problem-solving skills
  • Good communication and teamwork abilities
  • Experience with ETL processes is a plus
  • Knowledge of version control systems (e.g., Git) is desirable

Potential interview questions

Text copied to clipboard!
  • How many years of experience do you have with PL/SQL development?
  • Can you describe a challenging database issue you resolved?
  • What tools do you use for performance tuning and optimization?
  • How do you ensure code quality and maintainability?
  • Describe your experience with data modeling and database design.
  • Have you worked with ETL processes or data integration tasks?
  • How do you handle tight deadlines and multiple priorities?
  • What is your experience with Oracle database administration?
  • Are you familiar with version control systems?
  • How do you stay updated with new database technologies?